﻿// Copyright 2009 Mike Geise
// 
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
// 
//     http://www.apache.org/licenses/LICENSE-2.0
// 
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

namespace Falcon.Forums.SqlServer.Repositories.Parameters
{
	using System;
	using System.Data;
	using System.Data.SqlClient;
	using Falcon.Core.Extensions;
	using Falcon.Core.SqlServer.Repositories.Parameters;
	using Falcon.Forums.Domain;

	public class ForumTopicSpecificationParameter : ISpecificationParameter<ForumTopicSpecification>
	{
		/// <summary>
		/// Populates the specified parameters.
		/// </summary>
		/// <param name="parameters">The parameters.</param>
		/// <param name="specification">The specification.</param>
		public void Populate(SqlParameterCollection parameters, ForumTopicSpecification specification)
		{
			if (specification.ForumId > 0)
			{
				parameters.Add("@ForumID", SqlDbType.Int).Value = specification.ForumId;
			}

			if (specification.Slug.HasValue())
			{
				parameters.Add("@Slug", SqlDbType.NVarChar).Value = specification.Slug;
			}

			parameters.Add("@Scope", SqlDbType.Int).Value = specification.Scope;

			var table = new DataTable();

			table.Columns.Add(new DataColumn("Status", Type.GetType("System.Int32")));

			if (specification.Status != null)
			{
				for (var i = 0; i < specification.Status.Length; i++)
				{
					var row = table.NewRow();

					row["Status"] = (int)specification.Status[i];

					table.Rows.Add(row);
				}
			}

			parameters.Add("@Status", SqlDbType.Structured).Value = table;
		}
	}
}